/*

 $Id: $

*/

BEGIN TRANSACTION
GO

/*
	Table: 'phpbb_link'
*/
CREATE TABLE [phpbb_link] (
	[id] [varchar] (32) DEFAULT (0) NOT NULL ,
	[url] [varchar] (255) DEFAULT (0) NOT NULL ,
	[forum_id] [int] DEFAULT (0) NOT NULL ,
	[post_id] [int] DEFAULT (0) NOT NULL 
) ON [PRIMARY]
GO

CREATE  INDEX [id] ON [phpbb_link]([id]) ON [PRIMARY]
GO


/*
	Table: 'phpbb_cryptlink_data'
*/
CREATE TABLE [phpbb_cryptlink_data] (
	[link_id] [varchar] (32) DEFAULT (0) NOT NULL ,
	[user_id] [int] DEFAULT (0) NOT NULL ,
	[referer] [varchar] (4000) DEFAULT (0) NOT NULL 
) ON [PRIMARY]
GO

CREATE  INDEX [link_id] ON [phpbb_cryptlink_data]([link_id]) ON [PRIMARY]
GO

CREATE  INDEX [user_id] ON [phpbb_cryptlink_data]([user_id]) ON [PRIMARY]
GO



COMMIT
GO

